<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  

  
  <title>一起学Excel</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta property="og:type" content="website">
<meta property="og:title" content="一起学Excel">
<meta property="og:url" content="https://lecoder.gitee.io/study-excel/page/46/index.html">
<meta property="og:site_name" content="一起学Excel">
<meta property="og:locale" content="zh_CN">
<meta property="article:author" content="lijile">
<meta name="twitter:card" content="summary">
  
  
    <link rel="icon" href="/favicon.png">
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  
  
<link rel="stylesheet" href="/study-excel/css/style.css">

<meta name="generator" content="Hexo 6.3.0"></head>

<body>
  <div id="container">
    <div id="wrap">
      <header id="header">
  <div id="banner"></div>
  <div id="header-outer" class="outer">
    <div id="header-title" class="inner">
      <h1 id="logo-wrap">
        <a href="/study-excel/" id="logo">一起学Excel</a>
      </h1>
      
    </div>
    <div id="header-inner" class="inner">
      <nav id="main-nav">
        <a id="main-nav-toggle" class="nav-icon"></a>
        
          <a class="main-nav-link" href="/study-excel/">Home</a>
        
          <a class="main-nav-link" href="/study-excel/archives">Archives</a>
        
      </nav>
      <nav id="sub-nav">
        
        <a id="nav-search-btn" class="nav-icon" title="搜索"></a>
      </nav>
      <div id="search-form-wrap">
        <form action="//google.com/search" method="get" accept-charset="UTF-8" class="search-form"><input type="search" name="q" class="search-form-input" placeholder="Search"><button type="submit" class="search-form-submit">&#xF002;</button><input type="hidden" name="sitesearch" value="https://lecoder.gitee.io/study-excel"></form>
      </div>
    </div>
  </div>
</header>
      <div class="outer">
        <section id="main">
  
    <article id="post-excel-use-function" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-use-function/" class="article-date">
  <time datetime="2022-11-23T08:00:49.899Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-use-function/">Excel 中使用函数进行计算</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>Excel 提供多种类型内置函数，使用时直接函数名开始计算。</p>
<h3 id="计算财务数据"><a href="#计算财务数据" class="headerlink" title="计算财务数据"></a>计算财务数据</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_76d3ab4935ff51451e4323e55c2fc829.png"></p>
<h3 id="进行逻辑计算"><a href="#进行逻辑计算" class="headerlink" title="进行逻辑计算"></a>进行逻辑计算</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1284a282e98fd759ff009809f085ac29.png"></p>
<h3 id="进行文本处理"><a href="#进行文本处理" class="headerlink" title="进行文本处理"></a>进行文本处理</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_b159bb61b22755bbeff0eaf61007d7ae.png"></p>
<h3 id="日期与时间处理"><a href="#日期与时间处理" class="headerlink" title="日期与时间处理"></a>日期与时间处理</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_61a6c9532b6f655edabaf06628d8052a.png"></p>
<h3 id="进行查找与引用操作"><a href="#进行查找与引用操作" class="headerlink" title="进行查找与引用操作"></a>进行查找与引用操作</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_552a94b32b1fd0a648b83ae0a67c5158.png"></p>
<h3 id="数学计算"><a href="#数学计算" class="headerlink" title="数学计算"></a>数学计算</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_09e73b159c14f17ce35482e875819c27.png"></p>
<p>更多函数计算和运用请查看应用函数页面。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-use-function/" data-id="clatcwgim012excq67hqp7siv" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-basic-ui" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-basic-ui/" class="article-date">
  <time datetime="2022-11-23T08:00:49.883Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-basic-ui/">Excel 基本工作界面</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>当我们打开一个 Excel 文件时，其基本工作界面如下（以 Excel 2013 版本为例）：</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_d91f964fe9de441ea266fd6d1ba2b437.png"></p>
<h2 id="在-Excel-基本界面中有-6-个重要的区域"><a href="#在-Excel-基本界面中有-6-个重要的区域" class="headerlink" title="在 Excel 基本界面中有 6 个重要的区域"></a>在 Excel 基本界面中有 6 个重要的区域</h2><h3 id="1-快速访问工具栏。"><a href="#1-快速访问工具栏。" class="headerlink" title="1.快速访问工具栏。"></a>1.快速访问工具栏。</h3><p>快速访问工具栏是一个可自定义的工具栏，包含一组独立于当前显示的功能区上的选项卡的命令。默认情况下，有三个按钮，分别是“保存”、“撤销”和“恢复”。在快速访问工具栏上可以添加常用的功能，由此一键完成该命令，无需在功能区中查找使用。</p>
<h3 id="2-功能区。"><a href="#2-功能区。" class="headerlink" title="2.功能区。"></a>2.功能区。</h3><p>功能区中包含使用 Excel 时用到的功能。根据功能的性质，各项功能以选项卡的方式分成不同的组，可以方便地定位功能位置。常用的功能选项卡有，开始、插入、公式、数据和视图。</p>
<h3 id="3-名称框。"><a href="#3-名称框。" class="headerlink" title="3.名称框。"></a>3.名称框。</h3><p>名称框实时显示当前活动对象的名称，包括单元格的位置（以列标和行号表示）、图表名称、表格名称和自定义名称等。名称框还可以用于定位到目标单元格或其他类型对象。</p>
<h3 id="4-编辑栏。"><a href="#4-编辑栏。" class="headerlink" title="4.编辑栏。"></a>4.编辑栏。</h3><p>编辑栏显示当前单元格的内容，包括普通内容（数字、文本、日期、逻辑值等）、运算和函数公式。编辑栏还可用于编辑当前单元格的内容。</p>
<h3 id="5-工作表区域。"><a href="#5-工作表区域。" class="headerlink" title="5.工作表区域。"></a>5.工作表区域。</h3><p>一个工作簿可以包含多个工作表。工作表区域包含所有的数据，包括数字、文本内容、图表、窗体、形状等。使用左下角的工作表选项卡，点击工作表名称可切换到该工作表（也可使用Ctrl+Page Up 和 Ctrl + Page Down 进行切换）。</p>
<h3 id="6-状态栏。"><a href="#6-状态栏。" class="headerlink" title="6.状态栏。"></a>6.状态栏。</h3><p>状态栏实时显示 Excel 在当前进行的作业，包括公式计算进度、是否在录制宏等。状态栏还显示当前选中区域的汇总值，包括计数、求和、平均值、最小值和最大值等。具体显示何种汇总值，可以右键状态栏选择需要显示的值。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-basic-ui/" data-id="clatcwgcz00wqxcq695mn6d3c" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-qat-ui" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-qat-ui/" class="article-date">
  <time datetime="2022-11-23T08:00:49.883Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-qat-ui/">Excel 快速访问工具栏</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>快速访问工具栏是一个可自定义的工具栏，包含一组独立于当前显示的功能区上的选项卡的命令。默认情况下，有三个按钮，分别是“保存”、“撤销”和“恢复”。</p>
<p>在快速访问工具栏上可以添加常用的功能，由此一键完成该命令，无需在功能区中查找使用。在快速访问工具栏上使用以下方法可添加和删除功能命令按钮。</p>
<h2 id="快速添加功能区命令"><a href="#快速添加功能区命令" class="headerlink" title="快速添加功能区命令"></a>快速添加功能区命令</h2><p>1.在功能区中，找到需要添加的命令。</p>
<p>2.右键单击命令，在弹出的快捷菜单上单击“添加到快速访问工具栏”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_2315710367c450ea02c602c484831f7e.png"></p>
<h2 id="添加不在功能区的命令"><a href="#添加不在功能区的命令" class="headerlink" title="添加不在功能区的命令"></a>添加不在功能区的命令</h2><p>1.单击快速访问工具栏最右侧向下箭头，在弹出的菜单里，单击“其他命令”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_33d116c84d811feb0fde8ae2198c3dc3.png"></p>
<p>2.在”从下列位置选择命令“列表中，选择”不在功能区中的命令“。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_770bd867839499e69430c80f0ec46907.png"></p>
<h2 id="从快速访问工具栏中删除命令"><a href="#从快速访问工具栏中删除命令" class="headerlink" title="从快速访问工具栏中删除命令"></a>从快速访问工具栏中删除命令</h2><p>1.右键单击想要删除的命令，在弹出的快捷菜单中单击“从快速访问工具栏中删除”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_d67118a07c916295e53e261a782d1e8a.png"></p>
<h2 id="调整命令排列顺序"><a href="#调整命令排列顺序" class="headerlink" title="调整命令排列顺序"></a>调整命令排列顺序</h2><p>1.单击快速访问工具栏最右侧向下箭头，在弹出的菜单里，单击“其他命令”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_33d116c84d811feb0fde8ae2198c3dc3.png"></p>
<p>2.在“自定义快速访问工具栏”下，单击想要调整的命令，然后单击“上移”或“下移”箭头。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_61df9329113c8f418ec700effb935420.png"></p>
<h2 id="调整快速访问工具栏的显示位置"><a href="#调整快速访问工具栏的显示位置" class="headerlink" title="调整快速访问工具栏的显示位置"></a>调整快速访问工具栏的显示位置</h2><p>1.单击快速访问工具栏最右侧向下箭头，在弹出的菜单里，单击“在功能区下方&#x2F;上方显示”。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_eef4ac39e23f626a2bcb2ef94caf7cce.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-qat-ui/" data-id="clatcwghi011axcq6ak9a8df7" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-use-charts" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-use-charts/" class="article-date">
  <time datetime="2022-11-23T08:00:49.883Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-use-charts/">Excel 中使用图表展示数据</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>Excel 图表功能使一组数据按不同的维度图形化展示。图表可以使数据更容易理解并发现其中的规律。Excel 提供多种类型的图表，包括柱状图、折线图、雷达图、饼状图和面积图等。</p>
<h3 id="柱状图"><a href="#柱状图" class="headerlink" title="柱状图"></a>柱状图</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_5da7a8296490fb6ce917f2a3109f02c7.png"></p>
<h3 id="折线图"><a href="#折线图" class="headerlink" title="折线图"></a>折线图</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_0818bc5f0a255b60b39e66b23dd37b50.png"></p>
<p>更多图表类型和做法请查看图表与图形栏目。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-use-charts/" data-id="clatcwgil012cxcq6220e2bif" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-use-pivot-table" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-use-pivot-table/" class="article-date">
  <time datetime="2022-11-23T08:00:49.883Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-use-pivot-table/">Excel 中使用数据透视表进行数据分类汇总</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>数据透视表是 Excel 最强大的功能之一，可以方便地对数据进行汇总、分析、分类和展示，并且使用灵活。</p>
<p>以下根据某公司1年四季度各人员的销售业绩明细数据，包含员工所属分公司。利用 Excel 的数据透视表功能，对该公司销售数据从不同的方面进行分类汇总分析。</p>
<h3 id="源数据"><a href="#源数据" class="headerlink" title="源数据"></a>源数据</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_1a042a085848912b7b104e3c20781786.png"></p>
<h3 id="汇总各分公司按季度的销售额"><a href="#汇总各分公司按季度的销售额" class="headerlink" title="汇总各分公司按季度的销售额"></a>汇总各分公司按季度的销售额</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_5a36f99b59f47eaab48f18eba9b5f7ab.png"></p>
<h3 id="汇总人员年度销售业绩，并按从大到小排序"><a href="#汇总人员年度销售业绩，并按从大到小排序" class="headerlink" title="汇总人员年度销售业绩，并按从大到小排序"></a>汇总人员年度销售业绩，并按从大到小排序</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_b40a53e9c113c2907d2fe097f2b8b199.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-use-pivot-table/" data-id="clatcwgio012gxcq67tqu31lw" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-backstage-ui" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-backstage-ui/" class="article-date">
  <time datetime="2022-11-23T08:00:49.868Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-backstage-ui/">Excel 后台视图</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>后台视图从 Excel 2010 版本引入，管理工作簿的统一地点。在这里可以新建、打开、保存、另存、打印工作簿等工作。单击“选项”可进入详细的 Excel 设置面板。</p>
<p>进入后台视图很简单，在基本界面单击功能区左上角“文件”按钮进入后台视图。默认显示当前工作簿的信息页面。后台视图采用三栏式设计，分别是操作栏、信息栏和属性栏。</p>
<p>操作栏可以进行新建、打开、保存、另存、打印、共享和关闭等操作。还可以进入账户和选项页面。</p>
<p>信息栏中可以进行保护工作、检查工作簿、管理版本等操作。</p>
<p>属性栏包含工作簿的属性、相关日期和相关人员信息。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_deec926539ee0573db116c215a1ed16a.png"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-backstage-ui/" data-id="clatcwgct00wmxcq6ffj1b7cv" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-common-features" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-common-features/" class="article-date">
  <time datetime="2022-11-23T08:00:49.868Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-common-features/">Excel 常用功能术语</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <h2 id="选择性粘贴"><a href="#选择性粘贴" class="headerlink" title="选择性粘贴"></a>选择性粘贴</h2><p><strong>位置：</strong>功能区→开始→剪贴板</p>
<p><strong>说明：</strong>通过选择性粘贴可以将剪贴板的内容以不同的方式粘贴的目标区域。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_e5a22c44c96993d2edbaf94fc72b147b.png"></p>
<h2 id="条件格式"><a href="#条件格式" class="headerlink" title="条件格式"></a>条件格式</h2><p><strong>位置：</strong>功能区→开始→样式</p>
<p><strong>说明：</strong>使用条件格式对一个或多个单元格创建一定的规则，使其在符合规则时应用指定的单元格格式。创建的规则条件可以是基于当前单元格的内容或者其他单元格的内容。通过条件格式可以更改单元格以下属性：</p>
<ul>
<li>数字格式</li>
<li>字体、字形和字体颜色（不包括字体大小）</li>
<li>背景色和背景色填充效果</li>
<li>边框样式和边框颜色（不包括边框粗细）</li>
</ul>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_92773b96ce9c53e7089cfbb40580a842.png"></p>
<h2 id="排序和筛选"><a href="#排序和筛选" class="headerlink" title="排序和筛选"></a>排序和筛选</h2><p><strong>位置：</strong>功能区→开始→编辑 | 功能区→数据→排序和筛选</p>
<p><strong>说明：</strong>使用排序功能，可以对某一区域的数据进行按指定的条件排序，例如，从小到大排序、A-Z排序或者自定义顺序排序。使用筛选功能，可以对某一区域的数据进行按指定条件筛选。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_308ea1aa893c6935009bd92599206656.png"></p>
<h2 id="数据透视表"><a href="#数据透视表" class="headerlink" title="数据透视表"></a>数据透视表</h2><p><strong>位置：</strong>功能区→插入→表格</p>
<p><strong>说明：</strong>数据透视表是 Excel 最强大的功能之一，可以方便地对数据进行汇总、分析、分类和展示，并且使用灵活。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_ef6b6fe65f361cafa85cd814c417c788.png"></p>
<h2 id="表格"><a href="#表格" class="headerlink" title="表格"></a>表格</h2><p><strong>位置：</strong>功能区→插入→表格</p>
<p><strong>说明：</strong>使用“表格”功能，可以把某一区域转换成表格对象，使其具备更多内置功能，提高效率和准确度。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_ef6b6fe65f361cafa85cd814c417c788.png"></p>
<h2 id="图表"><a href="#图表" class="headerlink" title="图表"></a>图表</h2><p><strong>位置：</strong>功能区→插入→图表</p>
<p><strong>说明：</strong>Excel 图表功能使一组数据按不同的维度图形化展示。图表可以使数据更容易理解并发现其中的规律。Excel 提供多种类型的图表，包括柱状图、折线图、雷达图、饼状图和面积图等。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_cdf9ce7c63c110102e7506f2c0359082.png"></p>
<h2 id="迷你图"><a href="#迷你图" class="headerlink" title="迷你图"></a>迷你图</h2><p><strong>位置：</strong>功能区→插入→迷你图</p>
<p><strong>说明：</strong>Excel 迷你图是直接插入到单元格内的图表类型。相比传统的图表类型，迷你图与数据直接放在一起，数据与图表一起出现。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_59c83d4f430f7f81a06982628768e4d1.png"></p>
<h2 id="函数与公式"><a href="#函数与公式" class="headerlink" title="函数与公式"></a>函数与公式</h2><p><strong>位置：</strong>功能区→公式→函数库</p>
<p><strong>说明：</strong>函数与公式是 Excel 最常用的功能之一。公式对指定的数据进行数据计算或其他的一些操作，并返回结果。公式位于单元格内，并以等号（&#x3D;）开头。使用 Excel 内置函数和数学与算符可以写出各式各样的公式满足需求。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_955e69a9db7f7408dd60be2ba198075c.png"></p>
<h2 id="名称"><a href="#名称" class="headerlink" title="名称"></a>名称</h2><p><strong>位置：</strong>功能区→公式→定义的名称</p>
<p><strong>说明：</strong>使用定义的名称指定一个单元格、单元格区域、特定的值或者一个公式，使其代表的内容可以更方便的被使用。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_a404b3aae232901333e02dd8a58fc777.png"></p>
<h2 id="保护工作簿-x2F-工作表"><a href="#保护工作簿-x2F-工作表" class="headerlink" title="保护工作簿&#x2F;工作表"></a>保护工作簿&#x2F;工作表</h2><p><strong>位置：</strong>功能区→审阅→更改</p>
<p><strong>说明：</strong>使用 Excel 保护工作簿&#x2F;工作表功能，防止其他用户修改工作簿或工作表。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_54861d0a20511fc32b4b0e101c11b111.png"></p>
<h2 id="冻结窗格"><a href="#冻结窗格" class="headerlink" title="冻结窗格"></a>冻结窗格</h2><p><strong>位置：</strong>功能区→视图→窗口</p>
<p><strong>说明：</strong>使用冻结窗格功能，可以固定首行、首列或一部分行或列不对滚动而消失。此功能在冻结标题行或列时常用到。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_8f8a6428efd36a0d50d1b058063ebd48.png"></p>
<p> </p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-common-features/" data-id="clatcwgds00xgxcq65bgih8r1" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-edit-bar" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-edit-bar/" class="article-date">
  <time datetime="2022-11-23T08:00:49.868Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-edit-bar/">Excel 编辑栏</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>编辑栏显示当前单元格的内容，包括普通内容（数字、文本、日期、逻辑值等）、运算和函数公式。编辑栏还可用于编辑当前单元格的内容。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_770604841fc90208b306f9c7d096abbb.png"></p>
<h2 id="显示当前单元格的内容"><a href="#显示当前单元格的内容" class="headerlink" title="显示当前单元格的内容"></a>显示当前单元格的内容</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_7f8cd9f622b336b37e0e18a586d5510f.gif"></p>
<h2 id="编辑当前单元格内容"><a href="#编辑当前单元格内容" class="headerlink" title="编辑当前单元格内容"></a>编辑当前单元格内容</h2><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_9361bd7120d292a039b6e3575e6832a9.gif"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-edit-bar/" data-id="clatcwgei00yaxcq6514z0yov" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-name-cell" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-name-cell/" class="article-date">
  <time datetime="2022-11-23T08:00:49.868Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-name-cell/">Excel 名称框</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>名称框实时显示当前活动对象的名称信息，包括单元格的位置（以列标和行号表示）、图表名称、表格名称和自定义名称等。名称框还可以用于定位到目标单元格或其他类型对象。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_55624aa72ff2ec02a1334cce45a72c3b.png"></p>
<h2 id="显示当前选中对象的名称信息"><a href="#显示当前选中对象的名称信息" class="headerlink" title="显示当前选中对象的名称信息"></a>显示当前选中对象的名称信息</h2><h3 id="单元格"><a href="#单元格" class="headerlink" title="单元格"></a>单元格</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_4c390843949683c7e4fecfc0c0cf681f.png"></p>
<h3 id="形状"><a href="#形状" class="headerlink" title="形状"></a>形状</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_cb25e6a796a83ba78b1856cfe6c86dd8.png"></p>
<h3 id="图表"><a href="#图表" class="headerlink" title="图表"></a>图表</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_9403d307a39407e434db0ce265263719.png"></p>
<h3 id="自定义名称"><a href="#自定义名称" class="headerlink" title="自定义名称"></a>自定义名称</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_eb0628bd030865ee9b3c1e41ce7065b2.png"></p>
<h2 id="定位目标单元格区域或对象"><a href="#定位目标单元格区域或对象" class="headerlink" title="定位目标单元格区域或对象"></a>定位目标单元格区域或对象</h2><h3 id="定位目标单元格区域"><a href="#定位目标单元格区域" class="headerlink" title="定位目标单元格区域"></a>定位目标单元格区域</h3><p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_13a2a7486d8b2e4f55f661f3a3d377a5.gif"></p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-name-cell/" data-id="clatcwggu010mxcq679knb9r3" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  
    <article id="post-excel-ribbon-ui" class="article article-type-post" itemscope itemprop="blogPost">
  <div class="article-meta">
    <a href="/study-excel/excel-ribbon-ui/" class="article-date">
  <time datetime="2022-11-23T08:00:49.868Z" itemprop="datePublished">2022-11-23</time>
</a>
    
  <div class="article-category">
    <a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a>►<a class="article-category-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a>
  </div>

  </div>
  <div class="article-inner">
    
    
      <header class="article-header">
        
  
    <h1 itemprop="name">
      <a class="article-title" href="/study-excel/excel-ribbon-ui/">Excel 功能区</a>
    </h1>
  

      </header>
    
    <div class="article-entry" itemprop="articleBody">
      
        <p>功能区中包含使用 Excel 时用到的功能。根据功能性质，以三种组织方式分类显示在功能区中：</p>
<ul>
<li>选项卡（Tab） ：它们的位置在功能区上方部分，包含不同的相似功能组成的组。常用的选项卡 有，开始、插入、公式、数据和视图等。</li>
<li>组（Groups）： 一个组包含多个相似功能的命令，其名称显示在底部。例如，包含字体相关的命令在“字体”组中。</li>
<li>命令：每个命令在组中显示。</li>
</ul>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_8fbbd5c9b0932a80e928341662801c06.png"></p>
<p>关于功能区的常用操作如下：</p>
<h2 id="折叠-x2F-展开功能区"><a href="#折叠-x2F-展开功能区" class="headerlink" title="折叠&#x2F;展开功能区"></a>折叠&#x2F;展开功能区</h2><p><strong>方法一：</strong>双击任意一个选项卡的名称进行折叠&#x2F;展开操作。</p>
<p><strong>方法二：</strong>使用快捷键 Ctrl+F1 进行折叠&#x2F;展开操作。</p>
<p><strong>方法三：</strong>将光标移动到功能区，右键单击，在弹出快捷菜单中单击“”进行折叠&#x2F;展开操作。</p>
<p><img src="https://university-oss-2022.oss-cn-guangzhou.aliyuncs.com/easyexcel/uploads/im_a18aaa0db5ca70c2893ad5f3e9f1c9b7.png"></p>
<h2 id="切换选项卡"><a href="#切换选项卡" class="headerlink" title="切换选项卡"></a>切换选项卡</h2><p><strong>方法一：</strong>单击选项卡的名称。</p>
<p><strong>方法二：</strong>将光标移动到功能区，使用鼠标滚轮进行切换选项卡。</p>

      
    </div>
    <footer class="article-footer">
      <a data-url="https://lecoder.gitee.io/study-excel/excel-ribbon-ui/" data-id="clatcwghq011kxcq66oqjabws" class="article-share-link">Share</a>
      
      
    </footer>
  </div>
  
</article>


  


  <nav id="page-nav">
    
    <a class="extend prev" rel="prev" href="/study-excel/page/45/">&amp;laquo; 上一页</a><a class="page-number" href="/study-excel/">1</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/44/">44</a><a class="page-number" href="/study-excel/page/45/">45</a><span class="page-number current">46</span><a class="page-number" href="/study-excel/page/47/">47</a><a class="page-number" href="/study-excel/page/48/">48</a><span class="space">&hellip;</span><a class="page-number" href="/study-excel/page/94/">94</a><a class="extend next" rel="next" href="/study-excel/page/47/">下一页 &amp;raquo;</a>
  </nav>

</section>
        
          <aside id="sidebar">
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">分类</h3>
    <div class="widget">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/VBA/">VBA</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%85%AC%E5%BC%8F/">公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0/">函数</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">公式基础</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E9%94%99%E8%AF%AF/">公式错误</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD/">功能</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8A%9F%E8%83%BD%E5%8C%BA/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F/">公式</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/">单元格引用</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%8D%95%E5%85%83%E6%A0%BC%E5%BC%95%E7%94%A8/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E4%BD%BF%E7%94%A8-Excel/">使用 Excel</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F/">函数与公式</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/%E5%9F%BA%E7%A1%80/%E5%8D%95%E5%85%83%E6%A0%BC/">单元格</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E4%BF%9D%E5%AD%98%E8%AE%BE%E7%BD%AE/">保存设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%AC%E5%BC%8F%E8%AE%BE%E7%BD%AE/">公式设置</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E7%A1%80/%E5%85%B6%E4%BB%96%E8%AE%BE%E7%BD%AE/">其他设置</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/">基础</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E4%BF%9D%E6%8A%A4/">保护</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/">复制公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/">审阅</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%AE%A1%E9%98%85/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/">工作界面</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B7%A5%E4%BD%9C%E7%95%8C%E9%9D%A2/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/">常见术语</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%81%E6%9C%AF%E8%AF%AD/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/">常规设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%B8%B8%E8%A7%84%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/">开始</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E5%BC%80%E5%A7%8B/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/">插入</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%8F%92%E5%85%A5/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/">数据</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/">新增功能和函数</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2007/">Excel 2007</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2010/">Excel 2010</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2013/">Excel 2013</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%96%B0%E5%A2%9E%E5%8A%9F%E8%83%BD%E5%92%8C%E5%87%BD%E6%95%B0/Excel-2016/">Excel 2016</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/">校对设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E6%A0%A1%E5%AF%B9%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/">编写公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E5%86%99%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/">编辑公式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E7%BC%96%E8%BE%91%E5%85%AC%E5%BC%8F/%E5%87%BD%E6%95%B0%E4%B8%8E%E5%85%AC%E5%BC%8F%E5%9F%BA%E7%A1%80/">函数与公式基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/">视图</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E8%A7%86%E5%9B%BE/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/">页面布局</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%A1%B5%E9%9D%A2%E5%B8%83%E5%B1%80/%E5%8A%9F%E8%83%BD%E5%8C%BA/">功能区</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/">高级设置</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%AB%98%E7%BA%A7%E8%AE%BE%E7%BD%AE/%E5%9F%BA%E6%9C%AC%E8%AE%BE%E7%BD%AE/">基本设置</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/">鼠标指针</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80/%E9%BC%A0%E6%A0%87%E6%8C%87%E9%92%88/%E5%9F%BA%E6%9C%AC%E6%A6%82%E5%BF%B5/">基本概念</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/">基础操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/">复制与粘贴</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E5%A4%8D%E5%88%B6%E4%B8%8E%E7%B2%98%E8%B4%B4/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/">打印</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%89%93%E5%8D%B0/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/">查找与选择</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E6%9F%A5%E6%89%BE%E4%B8%8E%E9%80%89%E6%8B%A9/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/">编辑单元格格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%8D%95%E5%85%83%E6%A0%BC%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/">编辑工作表</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/">编辑工作表区域</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E5%B7%A5%E4%BD%9C%E8%A1%A8%E5%8C%BA%E5%9F%9F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/">编辑数字格式</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E7%BC%96%E8%BE%91%E6%95%B0%E5%AD%97%E6%A0%BC%E5%BC%8F/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/">鼠标操作</a><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%9F%BA%E7%A1%80%E6%93%8D%E4%BD%9C/%E9%BC%A0%E6%A0%87%E6%93%8D%E4%BD%9C/%E5%9F%BA%E7%A1%80/">基础</a></li></ul></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E5%BF%AB%E6%8D%B7%E9%94%AE/">快捷键</a></li><li class="category-list-item"><a class="category-list-link" href="/study-excel/categories/%E9%97%AE%E9%A2%98/">问题</a></li></ul>
    </div>
  </div>


  
    

  
    
  
    
  <div class="widget-wrap">
    <h3 class="widget-title">归档</h3>
    <div class="widget">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/study-excel/archives/2022/11/">十一月 2022</a></li></ul>
    </div>
  </div>


  
    
  <div class="widget-wrap">
    <h3 class="widget-title">最新文章</h3>
    <div class="widget">
      <ul>
        
          <li>
            <a href="/study-excel/excel-coupdaybs-function/">Excel COUPDAYBS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdays-function/">Excel COUPDAYS 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupdaysnc-function/">Excel COUPDAYSNC 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupncd-function/">Excel COUPNCD 函数</a>
          </li>
        
          <li>
            <a href="/study-excel/excel-coupnum-function/">Excel COUPNUM 函数</a>
          </li>
        
      </ul>
    </div>
  </div>

  
</aside>
        
      </div>
      <footer id="footer">
  
  <div class="outer">
    <div id="footer-info" class="inner">
      &copy; 2022 lijile<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>
    </div>
    <nav id="mobile-nav">
  
    <a href="/study-excel/" class="mobile-nav-link">Home</a>
  
    <a href="/study-excel/archives" class="mobile-nav-link">Archives</a>
  
</nav>
    

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>


  
<link rel="stylesheet" href="/study-excel/fancybox/jquery.fancybox.css">

  
<script src="/study-excel/fancybox/jquery.fancybox.pack.js"></script>




<script src="/study-excel/js/script.js"></script>




  </div>
</body>
</html>